USE [BMIG_Mensual_POST_CADENA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_M0002_VALORES_SEGUROS]    Script Date: 11/24/2011 14:38:15 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_M0002_VALORES_SEGUROS]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_M0002_VALORES_SEGUROS]
GO

USE [BMIG_Mensual_POST_CADENA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_M0002_VALORES_SEGUROS]    Script Date: 11/24/2011 14:38:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[WASP_M0002_VALORES_SEGUROS] 
AS 
BEGIN 
	SELECT	a.ppsuc
			,a.ppcta
			,a.ppoper
			,a.ppimp11
			,a.ppimp12
			,a.ppimp13 
			,a.ppimp14
			,a.ppimp15
			,a.ppimp16
			,a.ppimp17
			,a.ppimp18
			,a.ppimp19
	INTO	valores_seguros
	FROM	dbo.fsd611 AS a WITH (NOLOCK) CROSS JOIN
			dbo.fsd601 AS b WITH (NOLOCK)
	WHERE	(a.pptipo = '') 
	AND		(a.ppexte = 0) 
	AND		(a.ppsbop = 0) 
	AND		(a.pgcod = b.pgcod)
	AND		(a.ppmod = b.ppmod) 
	AND		(a.ppsuc = b.ppsuc) 
	AND		(a.ppmda = b.ppmda) 
	AND		(a.ppcta = b.ppcta) 
	AND		(a.ppoper = b.ppoper) 
	AND		(a.ppsbop = b.ppsbop) 
	AND		(a.pptope = b.pptope) 
	AND		(b.d601co = 'S')
	GROUP BY a.ppsuc
			,a.ppcta
			,a.ppoper
			,a.ppimp11
			,a.ppimp12
			,a.ppimp13
			,a.ppimp14
			,a.ppimp15
			,a.ppimp16
			,a.ppimp17
			,a.ppimp18
			,a.ppimp19
END

GO


